{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Home","Maturity Level","Methods Assessment","Tools Assessment","Review Result","Detailed Response Definitions","Sheet2","Review Result (2)"],"not_rendered":{"charts":4,"images":7,"macros":1,"external_links":0,"defined_names":6,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Self-Assessment Tool for Complex Project Management Maturity"]
[null,"Description"]
[]
[null,"This tool is to help the agency self-assess the current level of maturity of managing a complex project during the project development process in terms of project management functions related to 5DPM methods and tools. By answering each question on a scale of 1 to 5 (5 being the highest maturity), the agency can evaluate the organization’s maturity level of project management functions associated with 5DPM methods and tools. In addition, the self-assessment results can be used to rate the maturity level of each project development stage and the maturity level of the entire organization in managing complex projects by aggregating the answers of the individual questions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: This tool is developed only for answering the self-assessment questionnaire and showing the results. The entire questionnaire with full descriptions and recommendations are not provided here. Users should refer to the Appendix in the R10 report or the guidebook to use this tool."]

{"sheet":"Maturity Level","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Maturity Level Used in this Tool"]
[null,"Description"]
[]
[null,"To assess the maturity of complex project management, the five-staged maturity level is defined as below."]

{"sheet":"Methods Assessment","index":2,"n_rows":30,"n_cols":20,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,1,1,7],[2,1,2,7],[27,1,27,7]]}
[]
[null,"Self Assessment: 5DPM Project Planning Methods"]
[null,"Select an answer choice that most appropriately represents your agency's current level of use of the 5DPM planning method in each project stage."]
[]
[null,"  Current Practice",null,"Not considered","Ad-hoc basis or\nhire external expert","Process not well-defined\nor is project-specific","Standard process\nin effect","Additional feedback /\nLesson learned system"]
[null,"  I. Project Planning Stage"]
[null,null,"M01. Define Critical Project Success Factors",null,null,null,null,null,null,true,false,false,false,false,{"$f":"IF(J7=TRUE, 1, 0)","v":1},{"$f":"IF(K7=TRUE, 2, 0)","v":0},{"$f":"IF(L7=TRUE, 3, 0)","v":0},{"$f":"IF(M7=TRUE, 4, 0)","v":0},{"$f":"IF(N7=TRUE, 5, 0)","v":0},{"$f":"SUM(O7:S7)","v":1}]
[null,null,"M02. Assemble Project Team",null,null,null,null,null,null,true,false,false,false,false,{"$f":"IF(J8=TRUE, 1, 0)","v":1},{"$f":"IF(K8=TRUE, 2, 0)","v":0},{"$f":"IF(L8=TRUE, 3, 0)","v":0},{"$f":"IF(M8=TRUE, 4, 0)","v":0},{"$f":"IF(N8=TRUE, 5, 0)","v":0},{"$f":"SUM(O8:S8)","v":1}]
[null,null,"M05. Develop Project Action Plans to Address Resource Issues",null,null,null,null,null,null,true,false,false,false,false,{"$f":"IF(J9=TRUE, 1, 0)","v":1},{"$f":"IF(K9=TRUE, 2, 0)","v":0},{"$f":"IF(L9=TRUE, 3, 0)","v":0},{"$f":"IF(M9=TRUE, 4, 0)","v":0},{"$f":"IF(N9=TRUE, 5, 0)","v":0},{"$f":"SUM(O9:S9)","v":1}]
[]
[null,"  II. Programming Stage"]
[null,null,"M01. Define Critical Project Success Factors",null,null,null,null,null,null,true,false,false,false,false,{"$f":"IF(J12=TRUE, 1, 0)","v":1},{"$f":"IF(K12=TRUE, 2, 0)","v":0},{"$f":"IF(L12=TRUE, 3, 0)","v":0},{"$f":"IF(M12=TRUE, 4, 0)","v":0},{"$f":"IF(N12=TRUE, 5, 0)","v":0},{"$f":"SUM(O12:S12)","v":1}]
[null,null,"M02. Assemble Project Team",null,null,null,null,null,null,true,false,false,false,false,{"$f":"IF(J13=TRUE, 1, 0)","v":1},{"$f":"IF(K13=TRUE, 2, 0)","v":0},{"$f":"IF(L13=TRUE, 3, 0)","v":0},{"$f":"IF(M13=TRUE, 4, 0)","v":0},{"$f":"IF(N13=TRUE, 5, 0)","v":0},{"$f":"SUM(O13:S13)","v":1}]
[null,null,"M03. Select Project Arrangements",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"M04. Prepare Early Cost Model and Finance Plan",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"M05. Develop Project Action Plans to Address Resource Issues",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[]
[null,"  III. Preliminary Engineering Stage"]
[null,null,"M02. Assemble Project Team",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"M03. Select Project Arrangements",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"M04. Prepare Early Cost Model and Finance Plan",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"M05. Develop Project Action Plans to Address Resource Issues",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[]
[null,"  IV. Final Engineering Stage"]
[null,null,"M02. Assemble Project Team",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"M03. Select Project Arrangements",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"M05. Develop Project Action Plans to Address Resource Issues",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[]
[null,"  V. Construction Stage"]
[null,null,"M05. Develop Project Action Plans to Address Resource Issues",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]

{"sheet":"Tools Assessment","index":3,"n_rows":62,"n_cols":20,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,1,1,7],[2,1,2,7]]}
[]
[null,"Self Assessment: 5DPM Project Execution Tools"]
[null,"Select an answer choice that most appropriately represents your agency's current level of use of the 5DPM tool in each project stage."]
[]
[null,"  Current Practice",null,"Not considered","Ad-hoc basis or\nhire external expert","Process not well-defined\nor is project-specific","Standard process\nin effect","Additional feedback /\nLesson learned system"]
[null,"  I. Project Planning Stage"]
[null,null,"T01. Incentivize Critical Project Outcomes",null,null,null,null,null,null,true,false,false,false,false,{"$f":"IF(J7=TRUE, 1, 0)","v":1},{"$f":"IF(K7=TRUE, 2, 0)","v":0},{"$f":"IF(L7=TRUE, 3, 0)","v":0},{"$f":"IF(M7=TRUE, 4, 0)","v":0},{"$f":"IF(N7=TRUE, 5, 0)","v":0},{"$f":"SUM(O7:S7)","v":1}]
[null,null,"T03. Perform Comprehensive Risk Analysis",null,null,null,null,null,null,true,false,false,false,false,{"$f":"IF(J8=TRUE, 1, 0)","v":1},{"$f":"IF(K8=TRUE, 2, 0)","v":0},{"$f":"IF(L8=TRUE, 3, 0)","v":0},{"$f":"IF(M8=TRUE, 4, 0)","v":0},{"$f":"IF(N8=TRUE, 5, 0)","v":0},{"$f":"SUM(O8:S8)","v":1}]
[]
[null,"  II. Programming Stage"]
[null,null,"T01. Incentivize Critial Project Outcomes",null,null,null,null,null,null,true,false,false,false,false,{"$f":"IF(J11=TRUE, 1, 0)","v":1},{"$f":"IF(K11=TRUE, 2, 0)","v":0},{"$f":"IF(L11=TRUE, 3, 0)","v":0},{"$f":"IF(M11=TRUE, 4, 0)","v":0},{"$f":"IF(N11=TRUE, 5, 0)","v":0},{"$f":"SUM(O11:S11)","v":1}]
[null,null,"T02. Develop Dispute Resolutioin Plan",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T03. Perform Comprehensive Risk Analysis",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T06. Determine Required Level of Involvement in ROW/Utilities",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T07. Determine Work Package/Sequences",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T08. Design to Budget",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T11. Evaluate Flexible Financing",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T12. Develop Finance Expenditure Model",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T13. Establish Public Involvement Plan",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[]
[null,"  III. Preliminary Engineering Stage"]
[null,null,"T01. Incentivize Critial Project Outcomes",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T02. Develop Dispute Resolutioin Plan",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T03. Perform Comprehensive Risk Analysis",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T04. Identify Critical Permit Issues",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T05. Evaluate Application of Off-Site Fabrication",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T06. Determine Required Level of Involvement in ROW/Utilities",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T07. Determine Work Package/Sequences",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T08. Design to Budget",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T09. Co-Locate Team",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T10. Establish Flexible Design Criteria",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T11. Evaluate Flexible Financing",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T12. Develop Finance Expenditure Model",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T13. Establish Public Involvement Plan",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[]
[null,"  IV. Final Engineering Stage"]
[null,null,"T01. Incentivize Critial Project Outcomes",null,null,null,null,null,null,true,false,false,false,false,{"$f":"IF(J37=TRUE, 1, 0)","v":1},{"$f":"IF(K37=TRUE, 2, 0)","v":0},{"$f":"IF(L37=TRUE, 3, 0)","v":0},{"$f":"IF(M37=TRUE, 4, 0)","v":0},{"$f":"IF(N37=TRUE, 5, 0)","v":0},{"$f":"SUM(O37:S37)","v":1}]
[null,null,"T02. Develop Dispute Resolutioin Plan",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T03. Perform Comprehensive Risk Analysis",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T04. Identify Critical Permit Issues",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T05. Evaluate Application of Off-Site Fabrication",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T06. Determine Required Level of Involvement in ROW/Utilities",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T07. Determine Work Package/Sequences",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T08. Design to Budget",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T09. Co-Locate Team",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T10. Establish Flexible Design Criteria",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T11. Evaluate Flexible Financing",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T12. Develop Finance Expenditure Model",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T13. Establish Public Involvement Plan",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[]
[null,"  V. Construction Stage"]
[null,null,"T01. Incentivize Critial Project Outcomes",null,null,null,null,null,null,true,false,false,false,false,{"$f":"IF(J52=TRUE, 1, 0)","v":1},{"$f":"IF(K52=TRUE, 2, 0)","v":0},{"$f":"IF(L52=TRUE, 3, 0)","v":0},{"$f":"IF(M52=TRUE, 4, 0)","v":0},{"$f":"IF(N52=TRUE, 5, 0)","v":0},{"$f":"SUM(O52:S52)","v":1}]
[null,null,"T02. Develop Dispute Resolutioin Plan",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T03. Perform Comprehensive Risk Analysis",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T06. Determine Required Level of Involvement in ROW/Utilities",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T09. Co-Locate Team",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T13. Establish Public Involvement Plan",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[]
[null,"  VI. Operation and Maintenance Stage"]
[null,null,"T01. Incentivize Critial Project Outcomes",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T02. Develop Dispute Resolutioin Plan",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]
[null,null,"T03. Perform Comprehensive Risk Analysis",null,null,null,null,null,null,true,false,false,false,false,1,0,0,0,0,1]

{"sheet":"Review Result","index":4,"n_rows":57,"n_cols":29,"rows_kept":57,"cut":false,"hidden":false,"merged":[[32,11,32,12],[11,11,11,12],[1,1,1,9],[37,2,37,8],[47,2,47,8],[3,2,3,8],[13,2,13,8],[16,2,16,8]]}
[]
[null,"Maturity Assessment Result Review"]
[]
[null,null,"1) Maturity of 5DPM Project Planning Methods"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max","Maturity Level","Average"]
[null,null,null,"Method 1",{"$f":"'Methods Assessment'!T7","v":1},{"$f":"'Methods Assessment'!T12","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planning",5,{"$f":"E12","v":1},{"$f":"AVERAGE(AB6:AB10)","v":1}]
[null,null,null,"Method 2",{"$f":"'Methods Assessment'!T8","v":1},{"$f":"'Methods Assessment'!T13","v":1},{"$f":"'Methods Assessment'!T19","v":1},{"$f":"'Methods Assessment'!T25","v":1},null,null,null,"Optimized",5,null,null,null,null,null,null,null,null,null,null,null,null,"Program",5,{"$f":"F12","v":1},{"$f":"AC6","v":1}]
[null,null,null,"Method 3",null,{"$f":"'Methods Assessment'!T14","v":1},{"$f":"'Methods Assessment'!T20","v":1},{"$f":"'Methods Assessment'!T26","v":1},null,null,null,"Integrated",4,null,null,null,null,null,null,null,null,null,null,null,null,"Prelim. Eng",5,{"$f":"G12","v":1},{"$f":"AC7","v":1}]
[null,null,null,"Method 4",null,{"$f":"'Methods Assessment'!T15","v":1},{"$f":"'Methods Assessment'!T21","v":1},null,null,null,null,"Defined",3,null,null,null,null,null,null,null,null,null,null,null,null,"Final Eng",5,{"$f":"H12","v":1},1]
[null,null,null,"Method 5",{"$f":"'Methods Assessment'!T9","v":1},{"$f":"'Methods Assessment'!T16","v":1},{"$f":"'Methods Assessment'!T22","v":1},{"$f":"'Methods Assessment'!T27","v":1},{"$f":"'Methods Assessment'!T30","v":1},null,null,"Managed",2,null,null,null,null,null,null,null,null,null,null,null,null,"Constr.",5,{"$f":"I12","v":1},1]
[null,null,null,null,"Planning","Program","Prelim.","Final","Constr.","Operation",null,"Initial",1]
[null,null,null,"Maturity by Stage",{"$f":"AVERAGE(E6:E10)","v":1},{"$f":"AVERAGE(F6:F10)","v":1},1,1,1,"-",null,"Reference"]
[]
[]
[]
[]
[null,null,"2) Maturity of 5DPM Project Execution Tools"]
[]
[null,null,null,"Tool 1",{"$f":"'Tools Assessment'!T7","v":1},{"$f":"'Tools Assessment'!T11","v":1},{"$f":"'Tools Assessment'!T22","v":1},{"$f":"'Tools Assessment'!T37","v":1},{"$f":"'Tools Assessment'!T52","v":1},{"$f":"'Tools Assessment'!T60","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max","Maturity Level","Average"]
[null,null,null,"Tool 2",null,{"$f":"'Tools Assessment'!T12","v":1},{"$f":"'Tools Assessment'!T23","v":1},{"$f":"'Tools Assessment'!T38","v":1},{"$f":"'Tools Assessment'!T53","v":1},{"$f":"'Tools Assessment'!T61","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planning",5,{"$f":"E33","v":1},{"$f":"AVERAGE(AB20:AB25)","v":1}]
[null,null,null,"Tool 3",{"$f":"'Tools Assessment'!T8","v":1},{"$f":"'Tools Assessment'!T13","v":1},{"$f":"'Tools Assessment'!T24","v":1},{"$f":"'Tools Assessment'!T39","v":1},{"$f":"'Tools Assessment'!T54","v":1},{"$f":"'Tools Assessment'!T62","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program",5,{"$f":"F33","v":1},{"$f":"AC20","v":1}]
[null,null,null,"Tool 4",null,null,{"$f":"'Tools Assessment'!T25","v":1},{"$f":"'Tools Assessment'!T40","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prelim. Eng",5,{"$f":"G33","v":1},{"$f":"AC21","v":1}]
[null,null,null,"Tool 5",null,null,{"$f":"'Tools Assessment'!T26","v":1},{"$f":"'Tools Assessment'!T41","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Final Eng",5,{"$f":"H33","v":1},1]
[null,null,null,"Tool 6",null,{"$f":"'Tools Assessment'!T14","v":1},{"$f":"'Tools Assessment'!T27","v":1},{"$f":"'Tools Assessment'!T42","v":1},{"$f":"'Tools Assessment'!T55","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Constr.",5,{"$f":"I33","v":1},1]
[null,null,null,"Tool 7",null,{"$f":"'Tools Assessment'!T15","v":1},{"$f":"'Tools Assessment'!T28","v":1},{"$f":"'Tools Assessment'!T43","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operation/Maintenance",5,{"$f":"J33","v":1},1]
[null,null,null,"Tool 8",null,{"$f":"'Tools Assessment'!T16","v":1},{"$f":"'Tools Assessment'!T29","v":1},{"$f":"'Tools Assessment'!T44","v":1}]
[null,null,null,"Tool 9",null,null,{"$f":"'Tools Assessment'!T30","v":1},{"$f":"'Tools Assessment'!T45","v":1},{"$f":"'Tools Assessment'!T56","v":1}]
[null,null,null,"Tool 10",null,null,{"$f":"'Tools Assessment'!T31","v":1},{"$f":"'Tools Assessment'!T46","v":1},null,null,null,"Optimized",5]
[null,null,null,"Tool 11",null,{"$f":"'Tools Assessment'!T17","v":1},{"$f":"'Tools Assessment'!T32","v":1},{"$f":"'Tools Assessment'!T47","v":1},null,null,null,"Integrated",4]
[null,null,null,"Tool 12",null,{"$f":"'Tools Assessment'!T18","v":1},{"$f":"'Tools Assessment'!T33","v":1},{"$f":"'Tools Assessment'!T48","v":1},null,null,null,"Defined",3]
[null,null,null,"Tool 13",null,{"$f":"'Tools Assessment'!T19","v":1},{"$f":"'Tools Assessment'!T34","v":1},{"$f":"'Tools Assessment'!T49","v":1},{"$f":"'Tools Assessment'!T57","v":1},null,null,"Managed",2]
[null,null,null,null,"Planning","Program","Prelim.","Final","Constr.","Operation",null,"Initial",1]
[null,null,null,"Maturity by Stage",{"$f":"AVERAGE(E19:E31)","v":1},{"$f":"AVERAGE(F19:F31)","v":1},1,1,1,1,null,"Reference"]
[]
[]
[]
[]
[null,null,"3) Maturity of 5DPM Project Planning Methods - by the Five-Dimension"]
[]
[null,null,null,null,"Cost","Schedule","Technical","Finance","Context"]
[null,null,null," Planning",{"$f":"AVERAGE(E9:E10)","v":1},{"$f":"AVERAGE(E6,E8,E10)","v":1},{"$f":"AVERAGE(E6,E7,E8,E10)","v":1},{"$f":"AVERAGE(E6,E9,E10)","v":1},{"$f":"AVERAGE(E6:E10)","v":1}]
[null,null,null," Program",{"$f":"AVERAGE(F9:F10)","v":1},{"$f":"AVERAGE(F6,F8,F10)","v":1},{"$f":"AVERAGE(F6,F7,F8,F10)","v":1},{"$f":"AVERAGE(F6,F9,F10)","v":1},{"$f":"AVERAGE(F6:F10)","v":1}]
[null,null,null," Prelim. Eng.",{"$f":"AVERAGE(G9:G10)","v":1},{"$f":"AVERAGE(G6,G8,G10)","v":1},{"$f":"AVERAGE(G6,G7,G8,G10)","v":1},{"$f":"AVERAGE(G6,G9,G10)","v":1},{"$f":"AVERAGE(G6:G10)","v":1}]
[null,null,null," Final Eng.",{"$f":"AVERAGE(H9:H10)","v":1},{"$f":"AVERAGE(H6,H8,H10)","v":1},{"$f":"AVERAGE(H6,H7,H8,H10)","v":1},{"$f":"AVERAGE(H6,H9,H10)","v":1},{"$f":"AVERAGE(H6:H10)","v":1}]
[null,null,null," Constr.",{"$f":"AVERAGE(I9:I10)","v":1},{"$f":"AVERAGE(I6,I8,I10)","v":1},{"$f":"AVERAGE(I6,I7,I8,I10)","v":1},{"$f":"AVERAGE(I6,I9,I10)","v":1},{"$f":"AVERAGE(I6:I10)","v":1}]
[null,null,null,"Dimensional Rating",{"$f":"AVERAGE(E41:E45)","v":1},{"$f":"AVERAGE(F41:F45)","v":1},1,1,1]
[]
[null,null,"4) Maturity of 5DPM Project Execution Tools - by the Five-Dimension"]
[]
[null,null,null,null,"Cost","Schedule","Technical","Finance","Context"]
[null,null,null," Planning",{"$f":"AVERAGE(E19,E21)","v":1},{"$f":"AVERAGE(E19,E21)","v":1},{"$f":"AVERAGE(E19,E21)","v":1},{"$f":"E21","v":1},{"$f":"AVERAGE(E19,E21)","v":1}]
[null,null,null," Program",{"$f":"AVERAGE(F19,F21,F24,F26,F29)","v":1},{"$f":"AVERAGE(F19,F21,F24,F25,F29,F30,F31)","v":1},{"$f":"AVERAGE(F19,F20,F21,F24,F25,F26,F31)","v":1},{"$f":"AVERAGE(F21,F24,F26,F29,F30)","v":1},{"$f":"AVERAGE(F19,F20,F21,F24,F31)","v":1}]
[null,null,null," Prelim. Eng.",{"$f":"AVERAGE(G19,G21,G22,G24,G26,G27,G28,G29)","v":1},{"$f":"AVERAGE(G19,G21,G22,G23,G24,G25,G27,G28,G29,G30,G31)","v":1},{"$f":"AVERAGE(G19,G20,G21,G22,G23,G24,G25,G26,G28,G31)","v":1},{"$f":"AVERAGE(G19,G24,G26,G29,G30)","v":1},{"$f":"AVERAGE(G19:G24,G27:G28,G31)","v":1}]
[null,null,null," Final Eng.",{"$f":"AVERAGE(H19,H21,H22,H24,H26:H29)","v":1},{"$f":"AVERAGE(H19,H21,H22,H23,H24,H25,H27,H28,H29,H30,H31)","v":1},{"$f":"AVERAGE(H19,H20,H21,H22,H23,H24,H25,H26,H28,H31)","v":1},{"$f":"AVERAGE(H19,H24,H26,H29,H30)","v":1},{"$f":"AVERAGE(H19:H24,H27:H28,H31)","v":1}]
[null,null,null," Constr.",{"$f":"AVERAGE(I19,I21,I22,I24,I26:I29)","v":1},{"$f":"AVERAGE(I19,I21,I22,I23,I24,I25,I27,I28,I29,I30,I31)","v":1},{"$f":"AVERAGE(I19,I20,I21,I22,I23,I24,I25,I26,I28,I31)","v":1},{"$f":"AVERAGE(I19,I24,I26,I29,I30)","v":1},{"$f":"AVERAGE(I19:I24,I27:I28,I31)","v":1}]
[null,null,null," Operation/Maintenance",{"$f":"AVERAGE(J19,J21,J22,J24,J26:J29)","v":1},{"$f":"AVERAGE(J19,J21,J22,J23,J24,J25,J27,J28,J29,J30,J31)","v":1},{"$f":"AVERAGE(J19,J20,J21,J22,J23,J24,J25,J26,J28,J31)","v":1},{"$f":"AVERAGE(J19,J24,J26,J29,J30)","v":1},{"$f":"AVERAGE(J19:J24,J27:J28,J31)","v":1}]
[null,null,null,"Dimensional Rating",{"$f":"AVERAGE(E51:E56)","v":1},{"$f":"AVERAGE(F51:F56)","v":1},1,1,1]

{"sheet":"Detailed Response Definitions","index":5,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,2,3,6],[12,2,12,6]]}
[]
[]
[null,"General Question","Not considered","Ad-hoc basis or\nhire external expert","Process not well-defined\nor is project-specific","Standard process\nin effect","Additional feedback /\nLesson learned system","SHRP2 R-10 Case Study Example"]
[null,"Method","Detailed Explanation for Specific Method",null,null,null,null,"Method"]
[null,"M01. Define Critical Project Success Factors","We do not consider this method in this stage ","The project team may use their subjective judgments on an ad hoc basis or hire a subject matter expert ","The project team is supposed to do this task but the process is not well defined and it may vary from project to project ","We have a standard and documented process equivalent to this method.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process ","Saskatoon Green Streets Project"]
[null,"M02. Assemble Project Team","We do not consider this method in this stage ","The project team may use their subjective judgments on an ad hoc basis ","A routine process exists but may vary from project to project ","We have a standard and documented process equivalent to this method.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process ","Northern Gateway Toll Road"]
[null,"M03. Select Project Arrangements","We do not consider this method in this stage ","The project team may use their subjective judgments on an ad hoc basis  ","A routine process exists but may vary from project to project ","We have a standard and documented process equivalent to this method.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process "," Lewis and Clark Bridge"]
[null,"M04. Prepare Early Cost Model and Finance Plan","We do not consider this method in this stage ","The project team may use their subjective judgments on an ad hoc basis or hire a subject matter expert ","A routine process exists but may vary from project to project ","We have a standard and documented process equivalent to this method.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process "," North Carolina Tollway"]
[null,"M05. Develop Project Action Plans to Address Resource Issues","We do not consider this method in this stage ","The project team may use their subjective judgments on an ad hoc basis or hire a subject matter expert ","A routine process exists but may vary from project to project ","We have a standard and documented process equivalent to this method.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process "," Louisville-Southern Indiana Ohio River Bridges"]
[]
[]
[null,"General Question","Not considered","Ad-hoc basis or\nhire external expert","Process not well-defined\nor is project-specific","Standard process\nin effect","Additional feedback /\nLesson learned system","SHRP2 R-10 Case Study Example"]
[null,"Tool","Detailed Explanation for Specific Tool",null,null,null,null,"Tool"]
[null,"T01. Incentivize Critial Project Outcomes","We do not consider this particular tool in this stage ","The project team may consider this tool on an ad hoc basis.","A routine process that includes this tool exists but may vary from project to project ","We have a standard and documented process to utilize this tool if it is appropriate for the project.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process ","InterCounty Connector"]
[null,"T02. Develop Dispute Resolutioin Plan","We do not consider this particular tool in this stage ","The project team may consider this tool on an ad hoc basis or a subject matter expert might bring it up.","A routine process that includes this tool exists but may vary from project to project ","We have a standard and documented process to utilize this tool if it is appropriate for the project.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process ","InterCounty Connector"]
[null,"T03. Perform Comprehensive Risk Analysis","We do not consider this particular tool in this stage ","The project team may consider this tool on an ad hoc basis or a subject matter expert might bring it up.","A routine process that includes this tool exists but may vary from project to project ","We have a standard and documented process to utilize this tool if it is appropriate for the project.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process ","I-40 Crosstown Relocation"]
[null,"T04. Identify Critical Permit Issues","We do not consider this particular tool in this stage ","The project team may consider this tool on an ad hoc basis or a subject matter expert might bring it up.","A routine process that includes this tool exists but may vary from project to project ","We have a standard and documented process to utilize this tool if it is appropriate for the project.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process "," Louisville-Southern Indiana Ohio River Bridges"]
[null,"T05. Evaluate Application of Off-Site Fabrication","We do not consider this particular tool in this stage ","The project team may consider this tool on an ad hoc basis or a subject matter expert might bring it up.","A routine process that includes this tool exists but may vary from project to project ","We have a standard and documented process to utilize this tool if it is appropriate for the project.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process ","I-40 Crosstown Relocation"]
[null,"T06. Determine Required Level of Involvement in ROW/Utilities","We do not consider this particular tool in this stage ","The project team may consider this tool on an ad hoc basis or a subject matter expert might bring it up.","A routine process that includes this tool exists but may vary from project to project ","We have a standard and documented process to utilize this tool if it is appropriate for the project.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process "," T-REX"]
[null,"T07. Determine Work Package/Sequences","We do not consider this particular tool in this stage ","The project team may consider this tool on an ad hoc basis or a subject matter expert might bring it up.","A routine process that includes this tool exists but may vary from project to project ","We have a standard and documented process to utilize this tool if it is appropriate for the project.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process ","New Mississippi River Bridge"]
[null,"T08. Design to Budget","We do not consider this particular tool in this stage ","The project team may consider this tool on an ad hoc basis or a subject matter expert might bring it up.","A routine process that includes this tool exists but may vary from project to project ","We have a standard and documented process to utilize this tool if it is appropriate for the project.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process ","New Mississippi River Bridge"]
[null,"T09. Co-Locate Team","We do not consider this particular tool in this stage ","The project team may consider this tool on an ad hoc basis or a subject matter expert might bring it up.","A routine process that includes this tool exists but may vary from project to project ","We have a standard and documented process to utilize this tool if it is appropriate for the project.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process ","Northern Gateway Toll Road"]
[null,"T10. Establish Flexible Design Criteria","We do not consider this particular tool in this stage ","The project team may consider this tool on an ad hoc basis or a subject matter expert might bring it up.","A routine process that includes this tool exists but may vary from project to project ","We have a standard and documented process to utilize this tool if it is appropriate for the project.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process ","I-95 New Haven Harbor Crossing Corridor"]
[null,"T11. Evaluate Flexible Financing","We do not consider this particular tool in this stage ","The project team may consider this tool on an ad hoc basis or a subject matter expert might bring it up.","A routine process that includes this tool exists but may vary from project to project ","We have a standard and documented process to utilize this tool if it is appropriate for the project.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process ","Example: Detroit River International Crossing"]
[null,"T12. Develop Finance Expenditure Model","We do not consider this particular tool in this stage ","The project team may consider this tool on an ad hoc basis or a subject matter expert might bring it up.","A routine process that includes this tool exists but may vary from project to project ","We have a standard and documented process to utilize this tool if it is appropriate for the project.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process ","Example: I-95 New Haven Harbor Crossing Corridor"]
[null,"T13. Establish Public Involvement Plan","We do not consider this particular tool in this stage ","The project team may consider this tool on an ad hoc basis or a subject matter expert might bring it up.","A routine process that includes this tool exists but may vary from project to project ","We have a standard and documented process to utilize this tool if it is appropriate for the project.","In addition to previous item, there is a system for the feedback/lessons learned by collecting information after the project is completed in order to continuously improve the process ","James River Bridge"]

{"sheet":"Sheet2","index":6,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":true,"merged":[[34,13,39,13],[34,12,39,12],[3,1,3,7],[4,1,4,7],[39,10,39,11]]}
[]
[]
[]
[null,"Self Assessment: 5DPM Project Planning Methods"]
[null,"Select an answer choice that most appropriately represents your agency's current level of use of the 5DPM planning method in each project stage."]
[]
[null,"  Current Practice",null,"Not considered","Ad-hoc basis or\nhire external expert","Process not well-defined\nor is project-specific","Standard process\nin effect","Additional feedback /\nLessons learned system"]
[null,"  I. Project Planning Stage"]
[null,null,"M01. Define Critical Project Success Factors"]
[null,null,"M02. Assemble Project Team"]
[null,null,"M05. Develop Project Action Plans to Address Resource Issues"]
[]
[null,"  II. Programming Stage"]
[null,null,"M01. Define Critical Project Success Factors"]
[null,null,"M02. Assemble Project Team"]
[null,null,"M03. Select Project Arrangements"]
[null,null,"M04. Prepare Early Cost Model and Finance Plan"]
[null,null,"M05. Develop Project Action Plans to Address Resource Issues"]
[]
[null,"  III. Preliminary Engineering Stage"]
[null,null,"M02. Assemble Project Team"]
[null,null,"M03. Select Project Arrangements"]
[null,null,"M04. Prepare Early Cost Model and Finance Plan"]
[null,null,"M05. Develop Project Action Plans to Address Resource Issues"]
[]
[null,"  IV. Final Engineering Stage"]
[null,null,"M02. Assemble Project Team"]
[null,null,"M03. Select Project Arrangements"]
[null,null,"M05. Develop Project Action Plans to Address Resource Issues"]
[]
[null,"  V. Construction Stage"]
[null,null,"M05. Develop Project Action Plans to Address Resource Issues"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Optimized",5,"Desired                                                                                                                                               Improvement Possible"]
[null,null,null,null,null,null,null,null,null,null,"Integrated",4]
[null,null,null,null,null,null,null,null,null,null,"Defined",3]
[null,null,null,null,null,null,null,null,null,null,"Managed",2]
[null,null,null,null,null,null,null,null,null,null,"Initial",1]
[null,null,null,null,null,null,null,null,null,null,"Reference"]

{"sheet":"Review Result (2)","index":7,"n_rows":57,"n_cols":29,"rows_kept":57,"cut":false,"hidden":true,"merged":[[37,2,37,8],[47,2,47,8],[1,1,1,9],[3,2,3,8],[11,11,11,12],[13,2,13,8],[16,2,16,8],[32,11,32,12]]}
[]
[null,"Maturity Assessment Result Review"]
[]
[null,null,"1) Maturity of 5DPM Project Planning Methods"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max","Maturity Level","Average"]
[null,null,null,"Method 1",{"$f":"'Methods Assessment'!T7","v":1},{"$f":"'Methods Assessment'!T12","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planning",5,{"$f":"E12","v":1},{"$f":"AVERAGE(AB6:AB10)","v":1}]
[null,null,null,"Method 2",{"$f":"'Methods Assessment'!T8","v":1},{"$f":"'Methods Assessment'!T13","v":1},{"$f":"'Methods Assessment'!T19","v":1},{"$f":"'Methods Assessment'!T25","v":1},null,null,null,"Optimized",5,null,null,null,null,null,null,null,null,null,null,null,null,"Program",5,{"$f":"F12","v":1},{"$f":"AC6","v":1}]
[null,null,null,"Method 3",null,{"$f":"'Methods Assessment'!T14","v":1},{"$f":"'Methods Assessment'!T20","v":1},{"$f":"'Methods Assessment'!T26","v":1},null,null,null,"Integrated",4,null,null,null,null,null,null,null,null,null,null,null,null,"Prelim. Eng",5,{"$f":"G12","v":1},{"$f":"AC7","v":1}]
[null,null,null,"Method 4",null,{"$f":"'Methods Assessment'!T15","v":1},{"$f":"'Methods Assessment'!T21","v":1},null,null,null,null,"Defined",3,null,null,null,null,null,null,null,null,null,null,null,null,"Final Eng",5,{"$f":"H12","v":1},1]
[null,null,null,"Method 5",{"$f":"'Methods Assessment'!T9","v":1},{"$f":"'Methods Assessment'!T16","v":1},{"$f":"'Methods Assessment'!T22","v":1},{"$f":"'Methods Assessment'!T27","v":1},{"$f":"'Methods Assessment'!T30","v":1},null,null,"Managed",2,null,null,null,null,null,null,null,null,null,null,null,null,"Constr.",5,{"$f":"I12","v":1},1]
[null,null,null,null,"Planning","Program","Prelim.","Final","Constr.","Operation",null,"Initial",1]
[null,null,null,"Maturity by Stage",{"$f":"AVERAGE(E6:E10)","v":1},{"$f":"AVERAGE(F6:F10)","v":1},1,1,1,"-",null,"Reference"]
[]
[]
[]
[]
[null,null,"2) Maturity of 5DPM Project Execution Tools"]
[]
[null,null,null,"Tool 1",{"$f":"'Tools Assessment'!T7","v":1},{"$f":"'Tools Assessment'!T11","v":1},{"$f":"'Tools Assessment'!T22","v":1},{"$f":"'Tools Assessment'!T37","v":1},{"$f":"'Tools Assessment'!T52","v":1},{"$f":"'Tools Assessment'!T60","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max","Maturity Level","Average"]
[null,null,null,"Tool 2",null,{"$f":"'Tools Assessment'!T12","v":1},{"$f":"'Tools Assessment'!T23","v":1},{"$f":"'Tools Assessment'!T38","v":1},{"$f":"'Tools Assessment'!T53","v":1},{"$f":"'Tools Assessment'!T61","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planning",5,{"$f":"E33","v":1},{"$f":"AVERAGE(AB20:AB25)","v":1}]
[null,null,null,"Tool 3",{"$f":"'Tools Assessment'!T8","v":1},{"$f":"'Tools Assessment'!T13","v":1},{"$f":"'Tools Assessment'!T24","v":1},{"$f":"'Tools Assessment'!T39","v":1},{"$f":"'Tools Assessment'!T54","v":1},{"$f":"'Tools Assessment'!T62","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program",5,{"$f":"F33","v":1},{"$f":"AC20","v":1}]
[null,null,null,"Tool 4",null,null,{"$f":"'Tools Assessment'!T25","v":1},{"$f":"'Tools Assessment'!T40","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prelim. Eng",5,{"$f":"G33","v":1},{"$f":"AC21","v":1}]
[null,null,null,"Tool 5",null,null,{"$f":"'Tools Assessment'!T26","v":1},{"$f":"'Tools Assessment'!T41","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Final Eng",5,{"$f":"H33","v":1},1]
[null,null,null,"Tool 6",null,{"$f":"'Tools Assessment'!T14","v":1},{"$f":"'Tools Assessment'!T27","v":1},{"$f":"'Tools Assessment'!T42","v":1},{"$f":"'Tools Assessment'!T55","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Constr.",5,{"$f":"I33","v":1},1]
[null,null,null,"Tool 7",null,{"$f":"'Tools Assessment'!T15","v":1},{"$f":"'Tools Assessment'!T28","v":1},{"$f":"'Tools Assessment'!T43","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operation/Maintenance",5,{"$f":"J33","v":1},1]
[null,null,null,"Tool 8",null,{"$f":"'Tools Assessment'!T16","v":1},{"$f":"'Tools Assessment'!T29","v":1},{"$f":"'Tools Assessment'!T44","v":1}]
[null,null,null,"Tool 9",null,null,{"$f":"'Tools Assessment'!T30","v":1},{"$f":"'Tools Assessment'!T45","v":1},{"$f":"'Tools Assessment'!T56","v":1}]
[null,null,null,"Tool 10",null,null,{"$f":"'Tools Assessment'!T31","v":1},{"$f":"'Tools Assessment'!T46","v":1},null,null,null,"Optimized",5]
[null,null,null,"Tool 11",null,{"$f":"'Tools Assessment'!T17","v":1},{"$f":"'Tools Assessment'!T32","v":1},{"$f":"'Tools Assessment'!T47","v":1},null,null,null,"Integrated",4]
[null,null,null,"Tool 12",null,{"$f":"'Tools Assessment'!T18","v":1},{"$f":"'Tools Assessment'!T33","v":1},{"$f":"'Tools Assessment'!T48","v":1},null,null,null,"Defined",3]
[null,null,null,"Tool 13",null,{"$f":"'Tools Assessment'!T19","v":1},{"$f":"'Tools Assessment'!T34","v":1},{"$f":"'Tools Assessment'!T49","v":1},{"$f":"'Tools Assessment'!T57","v":1},null,null,"Managed",2]
[null,null,null,null,"Planning","Program","Prelim.","Final","Constr.","Operation",null,"Initial",1]
[null,null,null,"Maturity by Stage",{"$f":"AVERAGE(E19:E31)","v":1},{"$f":"AVERAGE(F19:F31)","v":1},1,1,1,1,null,"Reference"]
[]
[]
[]
[]
[null,null,"3) Maturity of 5DPM Project Planning Methods - by the Five-Dimension"]
[]
[null,null,null,null,"Cost","Schedule","Technical","Finance","Context"]
[null,null,null," Planning",{"$f":"AVERAGE(E9:E10)","v":1},{"$f":"AVERAGE(E6,E8,E10)","v":1},{"$f":"AVERAGE(E6,E7,E8,E10)","v":1},{"$f":"AVERAGE(E6,E9,E10)","v":1},{"$f":"AVERAGE(E6:E10)","v":1}]
[null,null,null," Program",{"$f":"AVERAGE(F9:F10)","v":1},{"$f":"AVERAGE(F6,F8,F10)","v":1},{"$f":"AVERAGE(F6,F7,F8,F10)","v":1},{"$f":"AVERAGE(F6,F9,F10)","v":1},{"$f":"AVERAGE(F6:F10)","v":1}]
[null,null,null," Prelim. Eng.",{"$f":"AVERAGE(G9:G10)","v":1},{"$f":"AVERAGE(G6,G8,G10)","v":1},{"$f":"AVERAGE(G6,G7,G8,G10)","v":1},{"$f":"AVERAGE(G6,G9,G10)","v":1},{"$f":"AVERAGE(G6:G10)","v":1}]
[null,null,null," Final Eng.",{"$f":"AVERAGE(H9:H10)","v":1},{"$f":"AVERAGE(H6,H8,H10)","v":1},{"$f":"AVERAGE(H6,H7,H8,H10)","v":1},{"$f":"AVERAGE(H6,H9,H10)","v":1},{"$f":"AVERAGE(H6:H10)","v":1}]
[null,null,null," Constr.",{"$f":"AVERAGE(I9:I10)","v":1},{"$f":"AVERAGE(I6,I8,I10)","v":1},{"$f":"AVERAGE(I6,I7,I8,I10)","v":1},{"$f":"AVERAGE(I6,I9,I10)","v":1},{"$f":"AVERAGE(I6:I10)","v":1}]
[null,null,null,"Dimensional Rating",{"$f":"AVERAGE(E41:E45)","v":1},{"$f":"AVERAGE(F41:F45)","v":1},1,1,1]
[]
[null,null,"4) Maturity of 5DPM Project Execution Tools - by the Five-Dimension"]
[]
[null,null,null,null,"Cost","Schedule","Technical","Finance","Context"]
[null,null,null," Planning",{"$f":"AVERAGE(E19,E21)","v":1},{"$f":"AVERAGE(E19,E21)","v":1},{"$f":"AVERAGE(E19,E21)","v":1},{"$f":"E21","v":1},{"$f":"AVERAGE(E19,E21)","v":1}]
[null,null,null," Program",{"$f":"AVERAGE(F19,F21,F24,F26,F29)","v":1},{"$f":"AVERAGE(F19,F21,F24,F25,F29,F30,F31)","v":1},{"$f":"AVERAGE(F19,F20,F21,F24,F25,F26,F31)","v":1},{"$f":"AVERAGE(F21,F24,F26,F29,F30)","v":1},{"$f":"AVERAGE(F19,F20,F21,F24,F31)","v":1}]
[null,null,null," Prelim. Eng.",{"$f":"AVERAGE(G19,G21,G22,G24,G26,G27,G28,G29)","v":1},{"$f":"AVERAGE(G19,G21,G22,G23,G24,G25,G27,G28,G29,G30,G31)","v":1},{"$f":"AVERAGE(G19,G20,G21,G22,G23,G24,G25,G26,G28,G31)","v":1},{"$f":"AVERAGE(G19,G24,G26,G29,G30)","v":1},{"$f":"AVERAGE(G19:G24,G27:G28,G31)","v":1}]
[null,null,null," Final Eng.",{"$f":"AVERAGE(H19,H21,H22,H24,H26:H29)","v":1},{"$f":"AVERAGE(H19,H21,H22,H23,H24,H25,H27,H28,H29,H30,H31)","v":1},{"$f":"AVERAGE(H19,H20,H21,H22,H23,H24,H25,H26,H28,H31)","v":1},{"$f":"AVERAGE(H19,H24,H26,H29,H30)","v":1},{"$f":"AVERAGE(H19:H24,H27:H28,H31)","v":1}]
[null,null,null," Constr.",{"$f":"AVERAGE(I19,I21,I22,I24,I26:I29)","v":1},{"$f":"AVERAGE(I19,I21,I22,I23,I24,I25,I27,I28,I29,I30,I31)","v":1},{"$f":"AVERAGE(I19,I20,I21,I22,I23,I24,I25,I26,I28,I31)","v":1},{"$f":"AVERAGE(I19,I24,I26,I29,I30)","v":1},{"$f":"AVERAGE(I19:I24,I27:I28,I31)","v":1}]
[null,null,null," Operation/Maintenance",{"$f":"AVERAGE(J19,J21,J22,J24,J26:J29)","v":1},{"$f":"AVERAGE(J19,J21,J22,J23,J24,J25,J27,J28,J29,J30,J31)","v":1},{"$f":"AVERAGE(J19,J20,J21,J22,J23,J24,J25,J26,J28,J31)","v":1},{"$f":"AVERAGE(J19,J24,J26,J29,J30)","v":1},{"$f":"AVERAGE(J19:J24,J27:J28,J31)","v":1}]
[null,null,null,"Dimensional Rating",{"$f":"AVERAGE(E51:E56)","v":1},{"$f":"AVERAGE(F51:F56)","v":1},1,1,1]